Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum





Please - Selecting Months automatically in View Columns
~Manny Nimtumizenli 01/23/2004 10:04 PM
Domino Designer 6.5 Windows 2000


Hello All,

Sorry - I know it's long to read but Please take look if you have some time. Thanks very much in Advance.

I have a view that shows dollar amounts for "This Month", "Next Month" and "Third Month". Every end of the month I have to go to this view and adjust the dates for the months mentioned above.

Please take a look at my code below, I am close but still not working like it should.



Current Code Below

@If (ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "90%"; netrevenue * 0.9 ;
ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "80%"; netrevenue * 0.8 ;
ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "60%"; netrevenue * 0.6 ;
ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "40%"; netrevenue * 0.4 ;
ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "20%"; netrevenue * 0.2 ; "")

My code attempt below to select automaticlly the "Third Month"

firstday := @Adjust(@Date(@Year(@Now); @Month(@Now);1); 0; 2; 0; 0; 0; 0);
@Adjust(firstday; 0; 0; 0; 0; 0; 0);
lastday := @Adjust(@Date(@Year(@Now); @Month(@Now);1); 0; 3; 0; 0; 0;0);
@Adjust(lastday; 0; 0; -1; 0; 0; 0);
@If (ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "90%"; netrevenue * 0.9 ;
ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "80%"; netrevenue * 0.8 ;
ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "60%"; netrevenue * 0.6 ;
ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "40%"; netrevenue * 0.4 ;
ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "20%"; netrevenue * 0.2 ; "")

Go back